/*
 Navicat Premium Data Transfer

 Source Server         : warehouse_db
 Source Server Type    : MySQL
 Source Server Version : 90200 (9.2.0)
 Source Host           : localhost:3306
 Source Schema         : warehouse_db

 Target Server Type    : MySQL
 Target Server Version : 90200 (9.2.0)
 File Encoding         : 65001

 Date: 02/03/2025 16:12:33
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for auth_group
-- ----------------------------
DROP TABLE IF EXISTS `auth_group`;
CREATE TABLE `auth_group` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `name` (`name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of auth_group
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for auth_group_permissions
-- ----------------------------
DROP TABLE IF EXISTS `auth_group_permissions`;
CREATE TABLE `auth_group_permissions` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `group_id` int NOT NULL,
  `permission_id` int NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `auth_group_permissions_group_id_permission_id_0cd325b0_uniq` (`group_id`,`permission_id`) USING BTREE,
  KEY `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` (`permission_id`) USING BTREE,
  CONSTRAINT `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `auth_group_permissions_group_id_b120cbf9_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of auth_group_permissions
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for auth_permission
-- ----------------------------
DROP TABLE IF EXISTS `auth_permission`;
CREATE TABLE `auth_permission` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `content_type_id` int NOT NULL,
  `codename` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `auth_permission_content_type_id_codename_01ab375a_uniq` (`content_type_id`,`codename`) USING BTREE,
  CONSTRAINT `auth_permission_content_type_id_2f476e4b_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of auth_permission
-- ----------------------------
BEGIN;
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (1, 'Can add log entry', 1, 'add_logentry');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (2, 'Can change log entry', 1, 'change_logentry');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (3, 'Can delete log entry', 1, 'delete_logentry');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (4, 'Can view log entry', 1, 'view_logentry');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (5, 'Can add permission', 2, 'add_permission');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (6, 'Can change permission', 2, 'change_permission');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (7, 'Can delete permission', 2, 'delete_permission');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (8, 'Can view permission', 2, 'view_permission');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (9, 'Can add group', 3, 'add_group');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (10, 'Can change group', 3, 'change_group');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (11, 'Can delete group', 3, 'delete_group');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (12, 'Can view group', 3, 'view_group');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (13, 'Can add user', 4, 'add_user');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (14, 'Can change user', 4, 'change_user');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (15, 'Can delete user', 4, 'delete_user');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (16, 'Can view user', 4, 'view_user');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (17, 'Can add content type', 5, 'add_contenttype');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (18, 'Can change content type', 5, 'change_contenttype');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (19, 'Can delete content type', 5, 'delete_contenttype');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (20, 'Can view content type', 5, 'view_contenttype');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (21, 'Can add session', 6, 'add_session');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (22, 'Can change session', 6, 'change_session');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (23, 'Can delete session', 6, 'delete_session');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (24, 'Can view session', 6, 'view_session');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (25, 'Can add customer', 7, 'add_customer');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (26, 'Can change customer', 7, 'change_customer');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (27, 'Can delete customer', 7, 'delete_customer');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (28, 'Can view customer', 7, 'view_customer');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (29, 'Can add goods', 8, 'add_goods');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (30, 'Can change goods', 8, 'change_goods');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (31, 'Can delete goods', 8, 'delete_goods');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (32, 'Can view goods', 8, 'view_goods');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (33, 'Can add user', 9, 'add_user');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (34, 'Can change user', 9, 'change_user');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (35, 'Can delete user', 9, 'delete_user');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (36, 'Can view user', 9, 'view_user');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (37, 'Can add sales order', 10, 'add_salesorder');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (38, 'Can change sales order', 10, 'change_salesorder');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (39, 'Can delete sales order', 10, 'delete_salesorder');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (40, 'Can view sales order', 10, 'view_salesorder');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (41, 'Can add sale detail', 11, 'add_saledetail');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (42, 'Can change sale detail', 11, 'change_saledetail');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (43, 'Can delete sale detail', 11, 'delete_saledetail');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (44, 'Can view sale detail', 11, 'view_saledetail');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (45, 'Can add report', 12, 'add_report');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (46, 'Can change report', 12, 'change_report');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (47, 'Can delete report', 12, 'delete_report');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (48, 'Can view report', 12, 'view_report');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (49, 'Can add inventory', 13, 'add_inventory');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (50, 'Can change inventory', 13, 'change_inventory');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (51, 'Can delete inventory', 13, 'delete_inventory');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (52, 'Can view inventory', 13, 'view_inventory');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (53, 'Can add blacklisted token', 14, 'add_blacklistedtoken');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (54, 'Can change blacklisted token', 14, 'change_blacklistedtoken');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (55, 'Can delete blacklisted token', 14, 'delete_blacklistedtoken');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (56, 'Can view blacklisted token', 14, 'view_blacklistedtoken');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (57, 'Can add outstanding token', 15, 'add_outstandingtoken');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (58, 'Can change outstanding token', 15, 'change_outstandingtoken');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (59, 'Can delete outstanding token', 15, 'delete_outstandingtoken');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (60, 'Can view outstanding token', 15, 'view_outstandingtoken');
COMMIT;

-- ----------------------------
-- Table structure for auth_user
-- ----------------------------
DROP TABLE IF EXISTS `auth_user`;
CREATE TABLE `auth_user` (
  `id` int NOT NULL AUTO_INCREMENT,
  `password` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `last_login` datetime(6) DEFAULT NULL,
  `is_superuser` tinyint(1) NOT NULL,
  `username` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `first_name` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `last_name` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `email` varchar(254) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `is_staff` tinyint(1) NOT NULL,
  `is_active` tinyint(1) NOT NULL,
  `date_joined` datetime(6) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `username` (`username`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of auth_user
-- ----------------------------
BEGIN;
INSERT INTO `auth_user` (`id`, `password`, `last_login`, `is_superuser`, `username`, `first_name`, `last_name`, `email`, `is_staff`, `is_active`, `date_joined`) VALUES (1, 'pbkdf2_sha256$600000$Gcs2n3VHZSG0ldUD7zzDEE$Z1e9Ve9rq/6Sf49TZp9BB+q+go2m28rojQ8fW9ZFhaI=', '2025-02-27 08:03:09.638895', 1, 'admin', '', '', 'admin@163.com', 1, 1, '2025-02-25 06:46:58.757515');
COMMIT;

-- ----------------------------
-- Table structure for auth_user_groups
-- ----------------------------
DROP TABLE IF EXISTS `auth_user_groups`;
CREATE TABLE `auth_user_groups` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `group_id` int NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `auth_user_groups_user_id_group_id_94350c0c_uniq` (`user_id`,`group_id`) USING BTREE,
  KEY `auth_user_groups_group_id_97559544_fk_auth_group_id` (`group_id`) USING BTREE,
  CONSTRAINT `auth_user_groups_group_id_97559544_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `auth_user_groups_user_id_6a12ed8b_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of auth_user_groups
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for auth_user_user_permissions
-- ----------------------------
DROP TABLE IF EXISTS `auth_user_user_permissions`;
CREATE TABLE `auth_user_user_permissions` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `permission_id` int NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `auth_user_user_permissions_user_id_permission_id_14a6b632_uniq` (`user_id`,`permission_id`) USING BTREE,
  KEY `auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm` (`permission_id`) USING BTREE,
  CONSTRAINT `auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `auth_user_user_permissions_user_id_a95ead1b_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of auth_user_user_permissions
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for django_admin_log
-- ----------------------------
DROP TABLE IF EXISTS `django_admin_log`;
CREATE TABLE `django_admin_log` (
  `id` int NOT NULL AUTO_INCREMENT,
  `action_time` datetime(6) NOT NULL,
  `object_id` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `object_repr` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `action_flag` smallint unsigned NOT NULL,
  `change_message` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `content_type_id` int DEFAULT NULL,
  `user_id` int NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `django_admin_log_content_type_id_c4bce8eb_fk_django_co` (`content_type_id`) USING BTREE,
  KEY `django_admin_log_user_id_c564eba6_fk_auth_user_id` (`user_id`) USING BTREE,
  CONSTRAINT `django_admin_log_content_type_id_c4bce8eb_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `django_admin_log_user_id_c564eba6_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `django_admin_log_chk_1` CHECK ((`action_flag` >= 0))
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of django_admin_log
-- ----------------------------
BEGIN;
INSERT INTO `django_admin_log` (`id`, `action_time`, `object_id`, `object_repr`, `action_flag`, `change_message`, `content_type_id`, `user_id`) VALUES (1, '2025-02-25 06:50:22.182395', '1', 'mary', 1, '[{\"added\": {}}]', 9, 1);
INSERT INTO `django_admin_log` (`id`, `action_time`, `object_id`, `object_repr`, `action_flag`, `change_message`, `content_type_id`, `user_id`) VALUES (2, '2025-02-25 06:53:18.304485', '1', 'xiaoming', 1, '[{\"added\": {}}]', 7, 1);
INSERT INTO `django_admin_log` (`id`, `action_time`, `object_id`, `object_repr`, `action_flag`, `change_message`, `content_type_id`, `user_id`) VALUES (3, '2025-02-25 06:54:48.861213', '2', 'xiaohong', 1, '[{\"added\": {}}]', 7, 1);
INSERT INTO `django_admin_log` (`id`, `action_time`, `object_id`, `object_repr`, `action_flag`, `change_message`, `content_type_id`, `user_id`) VALUES (4, '2025-02-25 06:56:15.758575', '1', '汽水', 1, '[{\"added\": {}}]', 8, 1);
COMMIT;

-- ----------------------------
-- Table structure for django_content_type
-- ----------------------------
DROP TABLE IF EXISTS `django_content_type`;
CREATE TABLE `django_content_type` (
  `id` int NOT NULL AUTO_INCREMENT,
  `app_label` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `model` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `django_content_type_app_label_model_76bd3d3b_uniq` (`app_label`,`model`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of django_content_type
-- ----------------------------
BEGIN;
INSERT INTO `django_content_type` (`id`, `app_label`, `model`) VALUES (1, 'admin', 'logentry');
INSERT INTO `django_content_type` (`id`, `app_label`, `model`) VALUES (3, 'auth', 'group');
INSERT INTO `django_content_type` (`id`, `app_label`, `model`) VALUES (2, 'auth', 'permission');
INSERT INTO `django_content_type` (`id`, `app_label`, `model`) VALUES (4, 'auth', 'user');
INSERT INTO `django_content_type` (`id`, `app_label`, `model`) VALUES (5, 'contenttypes', 'contenttype');
INSERT INTO `django_content_type` (`id`, `app_label`, `model`) VALUES (7, 'inventory', 'customer');
INSERT INTO `django_content_type` (`id`, `app_label`, `model`) VALUES (8, 'inventory', 'goods');
INSERT INTO `django_content_type` (`id`, `app_label`, `model`) VALUES (13, 'inventory', 'inventory');
INSERT INTO `django_content_type` (`id`, `app_label`, `model`) VALUES (12, 'inventory', 'report');
INSERT INTO `django_content_type` (`id`, `app_label`, `model`) VALUES (11, 'inventory', 'saledetail');
INSERT INTO `django_content_type` (`id`, `app_label`, `model`) VALUES (10, 'inventory', 'salesorder');
INSERT INTO `django_content_type` (`id`, `app_label`, `model`) VALUES (9, 'inventory', 'user');
INSERT INTO `django_content_type` (`id`, `app_label`, `model`) VALUES (6, 'sessions', 'session');
INSERT INTO `django_content_type` (`id`, `app_label`, `model`) VALUES (14, 'token_blacklist', 'blacklistedtoken');
INSERT INTO `django_content_type` (`id`, `app_label`, `model`) VALUES (15, 'token_blacklist', 'outstandingtoken');
COMMIT;

-- ----------------------------
-- Table structure for django_migrations
-- ----------------------------
DROP TABLE IF EXISTS `django_migrations`;
CREATE TABLE `django_migrations` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `app` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `applied` datetime(6) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of django_migrations
-- ----------------------------
BEGIN;
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (1, 'contenttypes', '0001_initial', '2025-02-25 06:16:18.930989');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (2, 'auth', '0001_initial', '2025-02-25 06:16:19.011341');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (3, 'admin', '0001_initial', '2025-02-25 06:16:19.034350');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (4, 'admin', '0002_logentry_remove_auto_add', '2025-02-25 06:16:19.037853');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (5, 'admin', '0003_logentry_add_action_flag_choices', '2025-02-25 06:16:19.041001');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (6, 'contenttypes', '0002_remove_content_type_name', '2025-02-25 06:16:19.061225');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (7, 'auth', '0002_alter_permission_name_max_length', '2025-02-25 06:16:19.073402');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (8, 'auth', '0003_alter_user_email_max_length', '2025-02-25 06:16:19.082326');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (9, 'auth', '0004_alter_user_username_opts', '2025-02-25 06:16:19.085953');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (10, 'auth', '0005_alter_user_last_login_null', '2025-02-25 06:16:19.097051');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (11, 'auth', '0006_require_contenttypes_0002', '2025-02-25 06:16:19.098007');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (12, 'auth', '0007_alter_validators_add_error_messages', '2025-02-25 06:16:19.101587');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (13, 'auth', '0008_alter_user_username_max_length', '2025-02-25 06:16:19.114172');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (14, 'auth', '0009_alter_user_last_name_max_length', '2025-02-25 06:16:19.127616');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (15, 'auth', '0010_alter_group_name_max_length', '2025-02-25 06:16:19.134422');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (16, 'auth', '0011_update_proxy_permissions', '2025-02-25 06:16:19.139110');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (17, 'auth', '0012_alter_user_first_name_max_length', '2025-02-25 06:16:19.151562');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (18, 'inventory', '0001_initial', '2025-02-25 06:16:19.244575');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (19, 'sessions', '0001_initial', '2025-02-25 06:16:19.248915');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (20, 'inventory', '0002_goods_current_quantity_goods_min_quantity_alert_and_more', '2025-02-27 09:05:12.964129');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (21, 'inventory', '0003_remove_goods_min_quantity_alert_and_more', '2025-02-28 01:02:50.465448');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (22, 'inventory', '0004_remove_goods_current_quantity_and_more', '2025-02-28 01:04:56.799781');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (23, 'inventory', '0005_remove_goods_total_inventory_goods_on_shelves_and_more', '2025-02-28 07:09:34.255696');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (24, 'token_blacklist', '0001_initial', '2025-03-02 05:55:41.002533');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (25, 'token_blacklist', '0002_outstandingtoken_jti_hex', '2025-03-02 05:55:41.018982');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (26, 'token_blacklist', '0003_auto_20171017_2007', '2025-03-02 05:55:41.025042');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (27, 'token_blacklist', '0004_auto_20171017_2013', '2025-03-02 05:55:41.043660');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (28, 'token_blacklist', '0005_remove_outstandingtoken_jti', '2025-03-02 05:55:41.055279');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (29, 'token_blacklist', '0006_auto_20171017_2113', '2025-03-02 05:55:41.062667');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (30, 'token_blacklist', '0007_auto_20171017_2214', '2025-03-02 05:55:41.101662');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (31, 'token_blacklist', '0008_migrate_to_bigautofield', '2025-03-02 05:55:41.142948');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (32, 'token_blacklist', '0010_fix_migrate_to_bigautofield', '2025-03-02 05:55:41.151856');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (33, 'token_blacklist', '0011_linearizes_history', '2025-03-02 05:55:41.152838');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (34, 'token_blacklist', '0012_alter_outstandingtoken_user', '2025-03-02 05:55:41.157174');
COMMIT;

-- ----------------------------
-- Table structure for django_session
-- ----------------------------
DROP TABLE IF EXISTS `django_session`;
CREATE TABLE `django_session` (
  `session_key` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `session_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `expire_date` datetime(6) NOT NULL,
  PRIMARY KEY (`session_key`) USING BTREE,
  KEY `django_session_expire_date_a5c62663` (`expire_date`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of django_session
-- ----------------------------
BEGIN;
INSERT INTO `django_session` (`session_key`, `session_data`, `expire_date`) VALUES ('0vuqy22vd230vxtpv4o82ggd7e8rj6cq', '.eJxVjDsOwjAQBe_iGlly1r9Q0nMGa9de4wCypTipIu5OIqWA9s3M20TAdSlh7TyHKYmrUOLyuxHGF9cDpCfWR5Ox1WWeSB6KPGmX95b4fTvdv4OCvew1RhsNOMrkCBisd0O01g9mxNFrrZxiQ5ghR9RIhMxIu6FsBkjZsPh8Afe2OPE:1tmokL:O8RJeSaMkx0alFI__iBs2C5Frpvc9LSvU-2CNiyhS8k', '2025-03-11 06:48:49.968385');
INSERT INTO `django_session` (`session_key`, `session_data`, `expire_date`) VALUES ('6ofplkc5s331d0c2b5vm5ex70bxv853c', '.eJxVjDsOwjAQBe_iGlly1r9Q0nMGa9de4wCypTipIu5OIqWA9s3M20TAdSlh7TyHKYmrUOLyuxHGF9cDpCfWR5Ox1WWeSB6KPGmX95b4fTvdv4OCvew1RhsNOMrkCBisd0O01g9mxNFrrZxiQ5ghR9RIhMxIu6FsBkjZsPh8Afe2OPE:1tnB2O:i2i0Pv9w9KpbUk2nvEqxNIJXsFbLjRZMI7NslR32uBM', '2025-03-12 06:36:56.051868');
INSERT INTO `django_session` (`session_key`, `session_data`, `expire_date`) VALUES ('xrbei9ul5sp92561jii0ltxf1mtoimh8', '.eJxVjDsOwjAQBe_iGlly1r9Q0nMGa9de4wCypTipIu5OIqWA9s3M20TAdSlh7TyHKYmrUOLyuxHGF9cDpCfWR5Ox1WWeSB6KPGmX95b4fTvdv4OCvew1RhsNOMrkCBisd0O01g9mxNFrrZxiQ5ghR9RIhMxIu6FsBkjZsPh8Afe2OPE:1tnYrN:tF-gOPN8kZfNzeNge1KzV31h_qZxG3tvrCFZ7tk1wqg', '2025-03-13 08:03:09.640647');
COMMIT;

-- ----------------------------
-- Table structure for inventory_customer
-- ----------------------------
DROP TABLE IF EXISTS `inventory_customer`;
CREATE TABLE `inventory_customer` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `customer_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `contact` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `email` varchar(254) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `created_at` datetime(6) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of inventory_customer
-- ----------------------------
BEGIN;
INSERT INTO `inventory_customer` (`id`, `customer_name`, `contact`, `address`, `email`, `created_at`) VALUES (1, 'xiaoming', '12345678910', '广东省广州市', '123@qq.com', '2025-02-25 06:53:18.303116');
INSERT INTO `inventory_customer` (`id`, `customer_name`, `contact`, `address`, `email`, `created_at`) VALUES (2, 'xiaohong', '12345678911', 'guangzhou', '678@qq.com', '2025-02-25 06:54:48.859899');
COMMIT;

-- ----------------------------
-- Table structure for inventory_goods
-- ----------------------------
DROP TABLE IF EXISTS `inventory_goods`;
CREATE TABLE `inventory_goods` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `goods_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `unit` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `image_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `created_at` datetime(6) NOT NULL,
  `on_shelves` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of inventory_goods
-- ----------------------------
BEGIN;
INSERT INTO `inventory_goods` (`id`, `goods_name`, `description`, `unit`, `price`, `image_url`, `created_at`, `on_shelves`) VALUES (1, '汽水', '可口可乐', '瓶', 3.00, NULL, '2025-02-25 06:56:15.757338', 1);
INSERT INTO `inventory_goods` (`id`, `goods_name`, `description`, `unit`, `price`, `image_url`, `created_at`, `on_shelves`) VALUES (2, '苹果', NULL, '元', 1.00, NULL, '2025-02-27 05:56:31.721262', 1);
INSERT INTO `inventory_goods` (`id`, `goods_name`, `description`, `unit`, `price`, `image_url`, `created_at`, `on_shelves`) VALUES (3, '1', NULL, '1', 1.00, NULL, '2025-02-27 06:58:06.768898', 0);
INSERT INTO `inventory_goods` (`id`, `goods_name`, `description`, `unit`, `price`, `image_url`, `created_at`, `on_shelves`) VALUES (4, '123', NULL, '元', 1.00, NULL, '2025-02-27 06:58:21.576636', 0);
INSERT INTO `inventory_goods` (`id`, `goods_name`, `description`, `unit`, `price`, `image_url`, `created_at`, `on_shelves`) VALUES (5, '1', NULL, '1', 23.00, NULL, '2025-02-27 06:58:50.936688', 0);
INSERT INTO `inventory_goods` (`id`, `goods_name`, `description`, `unit`, `price`, `image_url`, `created_at`, `on_shelves`) VALUES (6, '西瓜', NULL, '元', 1.00, NULL, '2025-02-27 07:08:30.487346', 0);
INSERT INTO `inventory_goods` (`id`, `goods_name`, `description`, `unit`, `price`, `image_url`, `created_at`, `on_shelves`) VALUES (7, '1', NULL, '元', 1.00, NULL, '2025-02-27 07:21:12.490699', 0);
INSERT INTO `inventory_goods` (`id`, `goods_name`, `description`, `unit`, `price`, `image_url`, `created_at`, `on_shelves`) VALUES (8, '1', NULL, '元', 1.00, NULL, '2025-02-27 07:44:43.382072', 0);
INSERT INTO `inventory_goods` (`id`, `goods_name`, `description`, `unit`, `price`, `image_url`, `created_at`, `on_shelves`) VALUES (9, '1', NULL, '元', 1.00, NULL, '2025-02-27 07:49:03.353158', 0);
INSERT INTO `inventory_goods` (`id`, `goods_name`, `description`, `unit`, `price`, `image_url`, `created_at`, `on_shelves`) VALUES (10, '1', NULL, '元', 1.00, NULL, '2025-02-27 08:26:11.759373', 0);
INSERT INTO `inventory_goods` (`id`, `goods_name`, `description`, `unit`, `price`, `image_url`, `created_at`, `on_shelves`) VALUES (11, '鸡腿', NULL, '个', 3.00, NULL, '2025-02-28 01:05:37.512457', 0);
COMMIT;

-- ----------------------------
-- Table structure for inventory_inventory
-- ----------------------------
DROP TABLE IF EXISTS `inventory_inventory`;
CREATE TABLE `inventory_inventory` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `current_quantity` int NOT NULL,
  `min_quantity_alert` int NOT NULL,
  `last_updated` datetime(6) NOT NULL,
  `goods_id` bigint NOT NULL,
  `total_inventory` int NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `inventory_inventory_goods_id_9dc19a27_fk_inventory_goods_id` (`goods_id`) USING BTREE,
  CONSTRAINT `inventory_inventory_goods_id_9dc19a27_fk_inventory_goods_id` FOREIGN KEY (`goods_id`) REFERENCES `inventory_goods` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of inventory_inventory
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for inventory_report
-- ----------------------------
DROP TABLE IF EXISTS `inventory_report`;
CREATE TABLE `inventory_report` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `report_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `report_date` datetime(6) NOT NULL,
  `file_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `generated_by_id` bigint NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `inventory_report_generated_by_id_01597121_fk_inventory_user_id` (`generated_by_id`) USING BTREE,
  CONSTRAINT `inventory_report_generated_by_id_01597121_fk_inventory_user_id` FOREIGN KEY (`generated_by_id`) REFERENCES `inventory_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of inventory_report
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for inventory_saledetail
-- ----------------------------
DROP TABLE IF EXISTS `inventory_saledetail`;
CREATE TABLE `inventory_saledetail` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `quantity` int NOT NULL,
  `unit_price` decimal(10,2) NOT NULL,
  `goods_id` bigint NOT NULL,
  `order_id` bigint NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `inventory_saledetail_goods_id_2e01b84f_fk_inventory_goods_id` (`goods_id`) USING BTREE,
  KEY `inventory_saledetail_order_id_310b15aa_fk_inventory` (`order_id`) USING BTREE,
  CONSTRAINT `inventory_saledetail_goods_id_2e01b84f_fk_inventory_goods_id` FOREIGN KEY (`goods_id`) REFERENCES `inventory_goods` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `inventory_saledetail_order_id_310b15aa_fk_inventory` FOREIGN KEY (`order_id`) REFERENCES `inventory_salesorder` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of inventory_saledetail
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for inventory_salesorder
-- ----------------------------
DROP TABLE IF EXISTS `inventory_salesorder`;
CREATE TABLE `inventory_salesorder` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `order_date` datetime(6) NOT NULL,
  `total_amount` decimal(10,2) NOT NULL,
  `status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `created_at` datetime(6) NOT NULL,
  `customer_id` bigint NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `inventory_salesorder_customer_id_a1ed9953_fk_inventory` (`customer_id`) USING BTREE,
  CONSTRAINT `inventory_salesorder_customer_id_a1ed9953_fk_inventory` FOREIGN KEY (`customer_id`) REFERENCES `inventory_customer` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of inventory_salesorder
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for inventory_user
-- ----------------------------
DROP TABLE IF EXISTS `inventory_user`;
CREATE TABLE `inventory_user` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `password` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `last_login` datetime(6) DEFAULT NULL,
  `is_superuser` tinyint(1) NOT NULL,
  `username` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `first_name` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `last_name` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `email` varchar(254) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `is_staff` tinyint(1) NOT NULL,
  `is_active` tinyint(1) NOT NULL,
  `date_joined` datetime(6) NOT NULL,
  `role` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `username` (`username`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of inventory_user
-- ----------------------------
BEGIN;
INSERT INTO `inventory_user` (`id`, `password`, `last_login`, `is_superuser`, `username`, `first_name`, `last_name`, `email`, `is_staff`, `is_active`, `date_joined`, `role`) VALUES (1, '123456', '2025-02-25 06:49:35.000000', 0, 'mary', '', '', '', 0, 1, '2025-02-25 06:49:20.000000', 'user');
INSERT INTO `inventory_user` (`id`, `password`, `last_login`, `is_superuser`, `username`, `first_name`, `last_name`, `email`, `is_staff`, `is_active`, `date_joined`, `role`) VALUES (2, 'pbkdf2_sha256$600000$18gbuDhI4mg3rHJWF6pBbf$uN/AytCrw56DdhMwhCKw4UwGR8JnMw7Brv2m7i6ve04=', NULL, 0, 'lisa', '', '', '', 0, 1, '2025-03-01 10:41:05.101541', 'user');
INSERT INTO `inventory_user` (`id`, `password`, `last_login`, `is_superuser`, `username`, `first_name`, `last_name`, `email`, `is_staff`, `is_active`, `date_joined`, `role`) VALUES (3, 'pbkdf2_sha256$600000$xR4bdaCpzIuVNUkCJq5Tu4$xoJZiJdxYVaQkLvraAdqyKQltwyrR2kzsczWqFBGk5c=', NULL, 0, 'mike', '', '', '', 0, 1, '2025-03-01 11:00:18.565096', 'user');
INSERT INTO `inventory_user` (`id`, `password`, `last_login`, `is_superuser`, `username`, `first_name`, `last_name`, `email`, `is_staff`, `is_active`, `date_joined`, `role`) VALUES (4, 'pbkdf2_sha256$600000$6pHL05zL7VJhjg0Yg9dtri$siuIrAqpckt0SaJEwvjnlbiq5fcOt8WLfyxMo6QRYv4=', NULL, 0, 'xiaoming', '', '', '', 0, 1, '2025-03-01 11:36:34.342979', 'user');
INSERT INTO `inventory_user` (`id`, `password`, `last_login`, `is_superuser`, `username`, `first_name`, `last_name`, `email`, `is_staff`, `is_active`, `date_joined`, `role`) VALUES (5, 'pbkdf2_sha256$600000$2ZDtBW2xA624agzMJZpL7o$Q5SAwl0HsRvGMh61aEJqdZj0T2DDJGQfkSekButFIvw=', NULL, 0, 'deepseek', '', '', '', 0, 1, '2025-03-02 05:53:21.307712', 'user');
COMMIT;

-- ----------------------------
-- Table structure for inventory_user_groups
-- ----------------------------
DROP TABLE IF EXISTS `inventory_user_groups`;
CREATE TABLE `inventory_user_groups` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `user_id` bigint NOT NULL,
  `group_id` int NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `inventory_user_groups_user_id_group_id_5c8e2e1b_uniq` (`user_id`,`group_id`) USING BTREE,
  KEY `inventory_user_groups_group_id_a0663023_fk_auth_group_id` (`group_id`) USING BTREE,
  CONSTRAINT `inventory_user_groups_group_id_a0663023_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `inventory_user_groups_user_id_75fc3376_fk_inventory_user_id` FOREIGN KEY (`user_id`) REFERENCES `inventory_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of inventory_user_groups
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for inventory_user_user_permissions
-- ----------------------------
DROP TABLE IF EXISTS `inventory_user_user_permissions`;
CREATE TABLE `inventory_user_user_permissions` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `user_id` bigint NOT NULL,
  `permission_id` int NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `inventory_user_user_perm_user_id_permission_id_1b3aae55_uniq` (`user_id`,`permission_id`) USING BTREE,
  KEY `inventory_user_user__permission_id_f2c61089_fk_auth_perm` (`permission_id`) USING BTREE,
  CONSTRAINT `inventory_user_user__permission_id_f2c61089_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `inventory_user_user__user_id_c72bfd7c_fk_inventory` FOREIGN KEY (`user_id`) REFERENCES `inventory_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of inventory_user_user_permissions
-- ----------------------------
BEGIN;
INSERT INTO `inventory_user_user_permissions` (`id`, `user_id`, `permission_id`) VALUES (1, 1, 35);
COMMIT;

-- ----------------------------
-- Table structure for token_blacklist_blacklistedtoken
-- ----------------------------
DROP TABLE IF EXISTS `token_blacklist_blacklistedtoken`;
CREATE TABLE `token_blacklist_blacklistedtoken` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `blacklisted_at` datetime(6) NOT NULL,
  `token_id` bigint NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `token_id` (`token_id`),
  CONSTRAINT `token_blacklist_blacklistedtoken_token_id_3cc7fe56_fk` FOREIGN KEY (`token_id`) REFERENCES `token_blacklist_outstandingtoken` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of token_blacklist_blacklistedtoken
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for token_blacklist_outstandingtoken
-- ----------------------------
DROP TABLE IF EXISTS `token_blacklist_outstandingtoken`;
CREATE TABLE `token_blacklist_outstandingtoken` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `token` longtext NOT NULL,
  `created_at` datetime(6) DEFAULT NULL,
  `expires_at` datetime(6) NOT NULL,
  `user_id` bigint DEFAULT NULL,
  `jti` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `token_blacklist_outstandingtoken_jti_hex_d9bdf6f7_uniq` (`jti`),
  KEY `token_blacklist_outs_user_id_83bc629a_fk_inventory` (`user_id`),
  CONSTRAINT `token_blacklist_outs_user_id_83bc629a_fk_inventory` FOREIGN KEY (`user_id`) REFERENCES `inventory_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of token_blacklist_outstandingtoken
-- ----------------------------
BEGIN;
INSERT INTO `token_blacklist_outstandingtoken` (`id`, `token`, `created_at`, `expires_at`, `user_id`, `jti`) VALUES (1, 'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ0b2tlbl90eXBlIjoicmVmcmVzaCIsImV4cCI6MTc0MDk4MTM4MSwiaWF0IjoxNzQwODk0OTgxLCJqdGkiOiJmNDIwYzRhYzJiYmE0NjJkYmQ5NGFiZGNjODFjMmY3NCIsInVzZXJfaWQiOjV9.4Pb5H59Ib-T44AV1MFSGlltB4fNFBDdCivlCcZJwGAk', '2025-03-02 05:56:21.816928', '2025-03-03 05:56:21.000000', 5, 'f420c4ac2bba462dbd94abdcc81c2f74');
INSERT INTO `token_blacklist_outstandingtoken` (`id`, `token`, `created_at`, `expires_at`, `user_id`, `jti`) VALUES (2, 'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ0b2tlbl90eXBlIjoicmVmcmVzaCIsImV4cCI6MTc0MDk4MTc5NCwiaWF0IjoxNzQwODk1Mzk0LCJqdGkiOiIyYWE5ODk1N2U5NzQ0MjUxOGFiZTI2YTA2ZjMxN2ZkOSIsInVzZXJfaWQiOjV9.cQiSD9EtGVQyPp2OxFnPEcuMFWBwuaxDg8KxSPJ1vXk', '2025-03-02 06:03:14.890476', '2025-03-03 06:03:14.000000', 5, '2aa98957e97442518abe26a06f317fd9');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
